﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="Search.aspx.vb" Inherits="HausaMathTermdev.Search" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">


<table width="100%">
<tr>
<td align="right"><asp:TextBox ID="TB_Search" runat="server"></asp:TextBox></td><td align="left"><asp:Button ID="btn_Search" runat="server" Text="Search" /></td>
</tr>
<tr>
<td align="center" colspan="2">
      <asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1" 
    AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" 
    DataKeyNames="TermID" Width= "100%">
        <Columns>
            <asp:BoundField DataField="Hausaterm" HeaderText="Hausa Term" 
                SortExpression="Hausaterm" >
            <ControlStyle CssClass="fontsize" Font-Bold="False" />
            <HeaderStyle CssClass="fontsize" HorizontalAlign="Center" 
                VerticalAlign="Middle" />
            </asp:BoundField>
            <asp:HyperLinkField DataNavigateUrlFields="TermID" 
                DataNavigateUrlFormatString="details.aspx?TermID={0}" 
                DataTextField="Mathterm" HeaderText="Math Term" SortExpression="Mathterm" />
            <asp:ImageField DataAlternateTextField="PictureSymbol" 
                DataImageUrlField="PictureSymbol" DataImageUrlFormatString="/image/{0}" 
                HeaderText=" Thumbnail" SortExpression="PictureSymbol">
                <ControlStyle CssClass="Thumbnail" />
                <ItemStyle CssClass="Thumbnail" />
            </asp:ImageField>
            <asp:BoundField DataField="Category" HeaderText="Category" SortExpression="Category" />
            <asp:BoundField DataField="Author" HeaderText="Author" SortExpression="Author" />
        </Columns>
    </asp:GridView>
      <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
        
        
        SelectCommand="SELECT [TermID], [Mathterm], [Hausaterm], [Definition], [PictureSymbol], [SiteAdd], [Remark], [Category], [Author], [DDate] FROM [Terms] WHERE ([Mathterm] = ?)">
        <SelectParameters>
            <asp:QueryStringParameter Name="Mathterm" QueryStringField="Mathterm" 
                Type="String" />
        </SelectParameters>
        </asp:SqlDataSource>
  </td>
</tr>
</table>

    


</asp:Content>
